/*
 Navicat Premium Data Transfer

 Source Server         : test
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 39.106.47.64:3306
 Source Schema         : StudentManageSystemDB

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 19/06/2018 15:59:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for Student2
-- ----------------------------
DROP TABLE IF EXISTS `Student2`;
CREATE TABLE `Student2` (
  `STID` int(25) NOT NULL AUTO_INCREMENT,
  `STNAME` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `STSEX` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `STAGE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `STTEL` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `STDEPT` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `STADDRESS` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `ROWID` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`STID`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of Student2
-- ----------------------------
BEGIN;
INSERT INTO `Student2` VALUES (1, '赵夕沐', '女', '16', '15825862120', '111', '天津', NULL);
INSERT INTO `Student2` VALUES (15, '孙策112', '男', '19', '13653548652', '电子', '重庆', 'AAANujAAEAAAAIQAAA');
INSERT INTO `Student2` VALUES (17, '李四', '女', '20', '16535476665', '农学', '北京', 'AAANujAAEAAAAIQAAC');
INSERT INTO `Student2` VALUES (18, '周文王', '女', '21', '15695845635', '历史', '庆阳', 'AAANujAAEAAAAIQAAD');
INSERT INTO `Student2` VALUES (19, '王芳', '女', '22', '12355668542', '音乐', '广州', 'AAANujAAEAAAAIQAAE');
INSERT INTO `Student2` VALUES (20, '红红', '女', '18', '16546542363', '历史', '福建', 'AAANujAAEAAAAIQAAF');
INSERT INTO `Student2` VALUES (21, '李逸', '男', '18', '14365976365', '物理', '济南', 'AAANujAAEAAAAIQAAG');
INSERT INTO `Student2` VALUES (22, '李', '男', '20', '15899635412', '计算机', '西安', 'AAANujAAEAAAAIQAAH');
INSERT INTO `Student2` VALUES (24, '大明', '男', '23', '15866742101', '计算机', '庆阳', 'AAANujAAEAAAAIPAAB');
INSERT INTO `Student2` VALUES (27, '哒哒哒', '女', '11', '111', '111', '111', NULL);
INSERT INTO `Student2` VALUES (30, '1', '男', '1', '1', '1', '1', NULL);
INSERT INTO `Student2` VALUES (33, '胡济洲', '男', '12', '1523211111', '计信院', '驱蚊器翁', NULL);
INSERT INTO `Student2` VALUES (34, '测试', '男', '423', '12312312312', '12', '23', NULL);
INSERT INTO `Student2` VALUES (35, '3333', '男', '3333', '333', '33', '33', NULL);
INSERT INTO `Student2` VALUES (36, '1', '男', '11', '11', '11', '11', NULL);
INSERT INTO `Student2` VALUES (37, '123', '男', '11', '11', '11', '11', NULL);
INSERT INTO `Student2` VALUES (38, '1111', '男', '212', '121', '212', '121', NULL);
INSERT INTO `Student2` VALUES (39, '1111', '男', '1', '1', '1', '1', NULL);
INSERT INTO `Student2` VALUES (40, '很委屈', '男', '11', '11', '11', '11', NULL);
INSERT INTO `Student2` VALUES (41, '444', '男', '444', '444', '444', '444', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_manager
-- ----------------------------
DROP TABLE IF EXISTS `t_manager`;
CREATE TABLE `t_manager` (
  `ID` int(20) NOT NULL AUTO_INCREMENT,
  `USERNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `PASSWORD` varchar(40) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_manager
-- ----------------------------
BEGIN;
INSERT INTO `t_manager` VALUES (1, 'shaohjz', '111');
INSERT INTO `t_manager` VALUES (2, 'root', 'password');
INSERT INTO `t_manager` VALUES (3, '111', '111');
INSERT INTO `t_manager` VALUES (4, '测试', '111');
INSERT INTO `t_manager` VALUES (5, '测试员', '111');
INSERT INTO `t_manager` VALUES (6, 'admin', 'admin');
INSERT INTO `t_manager` VALUES (62, '1111', '111');
INSERT INTO `t_manager` VALUES (63, '222', '222');
INSERT INTO `t_manager` VALUES (64, 'administrator', '111');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
